play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
HBAM3016AUG95@
Pro 3.0F!
Pro 3.0 - 4.1
Pro 3.0F!
Pro 3.0 - 4.0
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
7/1/99
-- REGISTER FIELDS --
ADDRESS
CAL DATE
CAL MONTH
CAL REP #
CAL YEAR
CALENDAR DISPLAY
CALENDARS
COMPANY
COUNTRY
DAYBOX
DAYBOX DISPLAY
DAYBOX REP #
EMAIL
FORMAT
INSTRUCTIONS
START
A CalendarsB
Cal DateB
Belimah
Calendar.fp3
FMP3FMP3
Birthday Tracker New
QBelimah:Applications:FileMaker Pro 4.1:Projects:Birthday Tracker New:Calendar.fp3
Temporary Folder
Belimah
Lunar
A Cal Rep #B
DayBox Rep #B
A Cal MonthB
Cal YearB
Calendar DisplayB
DayBox DisplayB
DayboxB
StartB
InstructionsB
FormatB
-- Register Fields --B
7/1/1999L
About this Demo...
This demonstration can be used as a beginning template or as a tutorial for learning calendar techniques. A general description of the methods used are included below. If you wish to learn more as well as access the calendar tools that are included in this file, please register.
Objective
To provide a calendar display for reference in FileMaker layouts and to provide an easy and convenient method for finding and/or selecting dates.
Solution
This demonstration proviii
CompanyB
AddressB
CityB
EmailB
CountryB
des instructions on building a monthly calendar that will serve as a date navigation tool. This routine will produce a user selected date, which can then be used as a match field for related data or as a factor in other field and script calculations.
Note: Field names are indicated in red italics.
As with most other tasks in FileMaker, there are a number of ways to attack any problem. This solution provides a fast and clean navigation system. The monthly calendar is a container field
which displays one of 28 possible monthly arrangements based on a calculated value. This was built with speed and user interface in mind. These calendars are low resolution
images and therefore are not suitable for printing. An alternative, albeit slower and more cumbersome, is to install each date in the monthly calendar as a calculated field. This will produce monthly calendars in the selected font for high resolution printing. A demo showing this alternative method is also
available.
The Date Field
The Date field (Cal Date) in this demo is defined as a global field. This will insure that the selected date will be a constant value across all records. Your database design may require that each record hold an assigned date and calendar configuration. In that case you should define the field as a regular date field. You will also pick up a little speed in the date navigation routines as a benefit.
Field Calculations
Click on the button, [Field Definitions/
Values] to see the calculations and observe how the values change according to the selected date.
The Calendars
The Calendars are held in a global container field, Calendars, defined with 28 repetitions, for the 28 possible monthly orientations. The selected calendar is displayed in the field, Calendar Display, that assigns the proper repetition from the global field based on the value in the number field, Cal Rep #.
Red Selection Highlight
There are 37 date positions in the monthly cal
endar. The red boxes for highlighting the selected date are held in the global field, DayBox, defined with 37 repetitions. The selected highlight position is displayed in the field, DayBox Display, that assigns the proper repetition from the global field based on the value in the number field, DayBox Rep #. You may be wondering...why not have a single graphic and calculate its placement on the calendar? That would require the installation of an additional 37 container fields, and the r
equired recalculations make the routine unacceptably slow.
Scripts
A transparent button is positioned over each grid space. Each button is attached to one of 37 scripts that sets the selected date and triggers the calculations for the proper monthly orientation and red highlight position. The first 6 and last 9 scripts begin with an
step to check for a valid date. A validity check is not necessary on the other grid positions.
Using this routine in your own file...
You can install
these routines into your file by simply using this demo as your beginning template or importing the global fields, Calendars and DayBox, into predefined fields in your file. Remember to define your fields as global container fields with the proper number of repetitions. Install the other fields and scripts as detailed in this file and you
re in business.
Graphic Elements
Click on the button, [Graphics/Layout Elements], to see the steps in building the calendar navigation tool. These p
arts are ready to assemble or can be customized. This demo contains some examples of various graphic styles that can be used with the calendar navigation tool. Use command-D or option-drag to duplicate the parts and drop your Calendar into one of the predesigned modules...group and install on your layout. Adjust the color of the weekday header, and accents as needed.
Important Note
You may choose to change the color of the grid lines in your calendar. Select the grid layout part and s
elect another color from the line color palette. Three of the calendars contain grid pieces for day positions 36 and 37. (bottom left) You must copy these from the repeating field, Calendar, then place them in a paint program and change the line to your selected grid color. The calendars needing adjustment are stored in repetitions 6, 7, and 14. After changing the color of the line, use the lasso tool to select, copy the calendar and then replace the older one in your file.
1997 by K
ADVANCED DATABASE SYSTEMS
0About this
Fields
FieldsB
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Startup
"------ Calendar Navigation -------
Date 1
Date 2
Date 3
Date 4
Date 5
Date 6
Date 7
Date 8
Date 9
Date 10
Date 11
Date 12
Date 13
Date 14
Date 15
Date 16
Date 17
Date 18
Date 19
Date 20
Date 21
Date 22
Date 23
Date 24
Date 25
Date 26
Date 27
Date 28
Date 29
Date 30
Date 31
Date 32
Date 33
Date 34
Date 35
Date 36
Date 37
----- Month Navigation ------
Next Month
Previous Month
------ Date Navigation -------
Next Day
Previous Day
Today
----- New Stuff -----
Jump to
Return
Get Some Coffee
333333
wwwwww
UUUUUU
DDDDDD
""""""
Cal Rep#
DayBox
Rep #
i'DayofWeek(Date(Cal Month,1,Cal Year))-1j|Case(Cal Month=4,30,Cal Month=6,30, Cal Month=9,30, Cal Month=11,30, Cal Month=2,Case(Cal Year/4=Int(Cal Year/4), 29,28),31)k6DayofWeek(Date(Cal Month,1,Cal Year)) +
To provide a calendar display for reference in FileMaker layouts and to provide an easy and convenient method for finding and/or selecting dates.
Solution
This demonstration provides instructions on building a monthly calendar that will serve as a date navigation tool. This routine will produce a user selected date, which can then be used as a match field for related data or as a factor in other field and script calculations.
As with most othethecalendar display for reference in FileMaker layouts and to provide an easy and convenient method for finding and/or selecting dates.
Solution
This demonstration provides instructions on building a monthly calendar that will serve as a date navigation tool. This routine will produce a user selected date, which can then be used as a match field for related data or as a factor in other field and script calculations.
As with most othe
r tasks in FileMaker, there are a number of ways to attack any problem. This solution provides a fast and clean navigation system. The monthly calendar is a container field which displays one of 28 possible monthly arrangements based on a calculated value. This was built with screen presentation and user interface in mind. These calendars are low resolution
images and therefore are not suitable for printing. An alternative, albeit slower and more cumbersome, is to install each
date in the monthly calendar as a calculated field. This will produce monthly calendars in the selected font for high resolution printing. A demo showing this alternative method is also available.
The Date Field
The Date field (Cal Date) in this demo is defined as a global field. This will insure that the selected date will be a constant value across all records. Your database design may require that each record hold an assigned date and calendar configuration. In that case you shoul
d define the field as a regular date field. You will also pick up a little speed in the date navigation routines as a benefit.
Field Calculations
Click on the button, [Field Definitions/Values] to see the calculations and observe how the values change according to the selected date.
The Calendars
The Calendars are held in a global container field, Calendars, defined with 28 repetitions, for the 28 possible monthly orientations. The selected calendar is displayed in the field, Calendar Di
splay, that assigns the proper repetition from the global field based on the value in the number field, Cal Rep #.
Red Selection Highlight
There are 37 date positions in the monthly calendar. The red boxes for highlighting the selected date are held in the global field, DayBox, defined with 37 repetitions. The selected highlight position is displayed in the field, DayBox Display, that assigns the proper repetition from the global field based on the value in the number field, DayBox Rep #
. You may be wondering...why not have a single graphic and calculate its placement on the calendar? That would require the installation of an additional 37 container fields, and the required recalculations make the routine unacceptably slow.
Scripts
A transparent button is positioned over each grid space. Each button is attached to one of 37 scripts that sets the selected date and triggers the calculations for the proper monthly orientation and red highlight position. The first 6 and
last 9 scripts begin with an
step to check for a valid date. A validity check is not necessary on the other grid positions.
Using this routine in your own file...
You can install these routines into your file by simply using this demo as your beginning template or importing the global fields, Calendars and DayBox, into predefined fields in your file. Remember to define your fields as global container fields with the proper number of repetitions. Install the other fields and scripts
as detailed in this file and you
re in business.
Graphic Elements
Click on the button, [Graphics/Layout Elements], to see the steps in building the calendar navigation tool. These parts are ready to assemble or can be customized. This demo contains some examples of various graphic styles that can be used with the calendar navigation tool. Use command-D or option-drag to duplicate the parts and drop your Calendar into one of the predesigned modules...group and install on your layout. A
djust the color of the weekday header and accents as needed.
Important Note
You may choose to change the color of the grid lines in your calendar. Select the layout part and select another color from the line color palette. Three of the calendars contain grid pieces for day positions 36 and 37. (bottom left) You must copy these from the repeating field, Calendar, then place them in a paint program and change the line to your selected grid color. The calendars needing adjustment are sto
ored in repetitions 6, 7, and 14. After changing the color of the line, use the lasso tool to select, copy the calendar and then replace the older one in your file.
(.txt)